﻿CREATE TABLE [dbo].[UDS_Staff_In_Role] (
    [Staff_ID] int NOT NULL,
    [Role_ID]  int NULL,

    CONSTRAINT [FK_UDS_Staff_In_Role_UDS_Role] FOREIGN KEY ([Role_ID]) REFERENCES [dbo].[UDS_Role] ([Role_ID]),
    CONSTRAINT [FK_UDS_Staff_In_Role_UDS_Staff] FOREIGN KEY ([Staff_ID]) REFERENCES [dbo].[UDS_Staff] ([Staff_ID])
);
GO

SET NOCOUNT ON
INSERT INTO dbo.[UDS_Staff_In_Role] (Staff_ID, Role_ID) VALUES(1, 1);
GO